package com.hawthorn.redis.repository.provider;

import com.hawthorn.component.constant.DicConstant;
import org.apache.ibatis.builder.annotation.ProviderMethodResolver;

/**
 * <p>todo todo 部门缓存sql类</p>
 * @author: andyten@tom.com | xukaixing@hotmail.com
 * @created: 2021/11/28 4:59 PM
 * @version v1.0.1
 * @copyright: Copyright (c)  andyten
 */
public class DeptCacheSqlProvider implements ProviderMethodResolver
{
  public static String selectDept()
  {
    String sql = "select  " +
        "id, " +
        "dcode, " +
        "dname, " +
        "sname, " +
        "ename, " +
        "pid, " +
        "dc, " +
        "level, " +
        "dept_type, " +
        "biz_type " +
        "dept_kind, " +
        "language, " +
        "biz_status, " +
        "company_id, " +
        "oem_company_id " +
        "from sys_dept " +
        "where status = " + DicConstant.YXBS_01 +
        " order by dcode";
    return sql;
  }
}
